﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LPY.LeHealth.DAL
{
    using LPY.LeHealth.DTO;
    using ServiceStack.OrmLite;

    /// <summary>
    /// 数据库管理类
    /// </summary>
    public class DataManager : BaseDAL
    {
        public bool InitailUser()
        {
            using (var cnn = DbConnection)
            {
                //创建用户表
                cnn.DropAndCreateTable<UserDTO>();
                //添加测试账号
                var usr = new UserDTO();
                usr.Name = "admin";
                usr.Password = "admin";
                usr.RoleId = 2;
                usr.ImgUrl = "";
                usr.TrueName = "金磊";
                new UserDAL().Add(usr);

                usr = new UserDTO();
                usr.Name = "user";
                usr.Password = "user";
                usr.PhoneNumber = "139999999";
                usr.RoleId = 0;
                usr.Gender = false;//女
                usr.ImgUrl = "";
                usr.TrueName = "立鑫";
                new UserDAL().Add(usr);
            }
            return true;
        }
        public bool InitailHospitalAdmin()
        {
            using (var cnn = DbConnection)
            {
                //创建用户表
                cnn.DropAndCreateTable<HospitalAdmin>();
                //添加测试账号
                var admin = new HospitalAdmin();
                admin.Uname = "admin";
                admin.Pwd = "admin";
                admin.HospitalId = 1;
                cnn.Insert<HospitalAdmin>(admin);

                admin.Uname = "admin2";
                admin.Pwd = "admin";
                admin.HospitalId = 2;
                cnn.Insert<HospitalAdmin>(admin);

                admin.Uname = "admin3";
                admin.Pwd = "admin";
                admin.HospitalId = 3;
                cnn.Insert<HospitalAdmin>(admin);

                admin.Uname = "admin4";
                admin.Pwd = "admin";
                admin.HospitalId = 4;
                cnn.Insert<HospitalAdmin>(admin);

                admin.Uname = "admin5";
                admin.Pwd = "admin";
                admin.HospitalId = 5;
                cnn.Insert<HospitalAdmin>(admin);

                admin.Uname = "admin6";
                admin.Pwd = "admin";
                admin.HospitalId = 6;
                cnn.Insert<HospitalAdmin>(admin);
                
            }
            return true;
        }
        


        public bool InitialHospital()
        {
            using (var cnn = DbConnection)
            {
                cnn.DropTable<OrderDetail>();
                cnn.DropTable<Cart>();
                cnn.DropTable<ComboDTO>();
                //需要提前删除该表，因为有外键引用
                cnn.DropTable<HospitalDTO>();

                //创建区域表
                cnn.DropAndCreateTable<AreaDTO>();
                cnn.Insert<AreaDTO>(new AreaDTO() { Name = "海淀区" });
                cnn.Insert<AreaDTO>(new AreaDTO() { Name = "朝阳区" });
                cnn.Insert<AreaDTO>(new AreaDTO() { Name = "东城区" });
                cnn.Insert<AreaDTO>(new AreaDTO() { Name = "西城区" });
                cnn.Insert<AreaDTO>(new AreaDTO() { Name = "昌平区" });

                //添加等级
                cnn.DropAndCreateTable<GradeDTO>();
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "公立三甲" });
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "公立二甲" });
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "公立一甲" });
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "私立三甲" });
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "私立二甲" });
                cnn.Insert<GradeDTO>(new GradeDTO() { Name = "私立一甲" });

                //创建医院表
                cnn.DropAndCreateTable<HospitalDTO>();
                //添加测试医院
                var hospital = new HospitalDTO();
                hospital.Address = "北京市海淀区";
                hospital.AreaId = 1;
                hospital.Detail = "中国人民解放军总医院前身是中国协和医学院第二临床学院，1953年10月，总后方勤务部卫生部决定将“中国协和医学院第二临床学院”改为“军委直属机关医院”。1954年7月，总后方勤务部卫生部将“军委直属机关医院”改为“中国人民解放军第三0一医院”。1957年6月，国防部批示“中国人民解放军第三0一医院”番号撤销，改称为“中国人民解放军总医院”。军医进修学院是以解放军总医院为依托建设和发展起来的，始建于1958年11月，1962年停办。1979年6月，经中央军委批准恢复军医进修学院。1986年9月批准正式列入全军院校编制序号。2004年全军整编将三0四医院更名为三0四临床部，对外称解放军总医院第一附属医院，列入解放军总医院编制序列。";
                hospital.Name = "中国人民解放军总医院";
                hospital.GradeId = 1;
                hospital.ExamTime = "周一至周五7.30-11.30";
                hospital.AppointmentDay = 1;//提前1天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                hospital = new HospitalDTO();
                hospital.Address = "北京市海淀区中关村南大街甲32号5层";
                hospital.AreaId = 2;
                hospital.Detail = "北京爱康国宾白石门诊部有限公司)地处国家图书馆对面，紧靠中央民族大学，中关村，地铁4号线国家图书馆站，多条公交线路直达，交通方便。所在中关 村科技发展大厦6层，占地600多平米，实行男女分区域、分诊室、分项目的健康体检流程。受检区域环境舒适私密；设备先进；医师临床经验丰富，给您带来更 舒心的健康体检服务。";
                hospital.Name = "北京爱康国宾体检中心";
                hospital.GradeId = 4;
                hospital.ExamTime = "周一至周五7：30-11：30";
                hospital.AppointmentDay = 3;//提前3天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                hospital = new HospitalDTO();
                hospital.Address = "北京西城区宣内大街油坊胡同36号";
                hospital.AreaId = 1;
                hospital.Detail = "北京中医药大学第三附属医院体检中心于2006年成立。体检中心充分依托北京中医药大学第三附属医院的综合实力和品牌影响，整合了医院强大的专家人力和设备资源，努力打造高品质的健康管理服务平台。";
                hospital.Name = "北京市第二医院体检中心";
                hospital.GradeId = 4;
                hospital.ExamTime = "周一至周五8:00-16:45（10:40 截止抽血）";
                hospital.AppointmentDay = 2;//提前2天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                hospital = new HospitalDTO();
                hospital.Address = "北京市海淀区中关村南大街甲32号5层";
                hospital.AreaId = 2;
                hospital.Detail = "北京爱康国宾白石门诊部有限公司)地处国家图书馆对面，紧靠中央民族大学，中关村，地铁4号线国家图书馆站，多条公交线路直达，交通方便。所在中关 村科技发展大厦6层，占地600多平米，实行男女分区域、分诊室、分项目的健康体检流程。受检区域环境舒适私密；设备先进；医师临床经验丰富，给您带来更 舒心的健康体检服务。";
                hospital.Name = "北京爱康国宾体检中心";
                hospital.GradeId = 4;
                hospital.ExamTime = "周一至周五7：30-11：30";
                hospital.AppointmentDay = 3;//提前3天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                hospital = new HospitalDTO();
                hospital.Address = "北京市海淀区中关村南大街甲32号5层";
                hospital.AreaId = 2;
                hospital.Detail = "北京爱康国宾白石门诊部有限公司)地处国家图书馆对面，紧靠中央民族大学，中关村，地铁4号线国家图书馆站，多条公交线路直达，交通方便。所在中关 村科技发展大厦6层，占地600多平米，实行男女分区域、分诊室、分项目的健康体检流程。受检区域环境舒适私密；设备先进；医师临床经验丰富，给您带来更 舒心的健康体检服务。";
                hospital.Name = "北京爱康国宾体检中心";
                hospital.GradeId = 4;
                hospital.ExamTime = "周一至周五7：30-11：30";
                hospital.AppointmentDay = 3;//提前3天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                hospital = new HospitalDTO();
                hospital.Address = "北京市昌平区昌金路6号";
                hospital.AreaId = 5;
                hospital.Detail = "北京昌平政和中医医院成立于2000年，占地面积5800平米，现开放病床60张，是国内首家胸科医 院，医院坐落于北京市昌平，绿树婆娑、空气新鲜、环境幽雅，为病人创造了舒适温馨的就医环境。";
                hospital.Name = "北京市政和中医院体检中心";
                hospital.GradeId = 2;
                hospital.ExamTime = "周一至周五8:30-12:00，13:00-16:30 （10:30后截止抽血）";
                hospital.AppointmentDay = 1;//提前1天预约
                hospital.CreateTime = DateTime.Now;
                new HospitalDAL().Add(hospital);

                //创建排班表
                cnn.DropAndCreateTable<DutyDTO>();
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(1), Number = 20 });
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(2), Number = 20 });
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(3), Number = 20 });
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(4), Number = 20 });
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(5), Number = 20 });
                cnn.Insert<DutyDTO>(new DutyDTO() { HospitalId = 1, Day = DateTime.Now.AddDays(6), Number = 20 });

            }

            return true;
        }

        //初始化体检数据
        public bool InitialPhysical()
        {
            using (var cnn = DbConnection)
            {
                //删除ComboDTO外键关联表
                cnn.DropTable<OrderDetail>();
                cnn.DropTable<Cart>();
                cnn.DropTable<ComboDTO>();

                //重新创建ComboDTO表
                cnn.DropAndCreateTable<ComboTypeDTO>();
                cnn.DropAndCreateTable<ComboDTO>();

                cnn.DropAndCreateTable<PhysicalItemDTO>();
                cnn.DropAndCreateTable<PhysicalItemType>();

                cnn.DropAndCreateTable<ComboToPhysicalItemDTO>();


                #region 添加体检项类型

                var pis = new List<PhysicalItemType>();
                pis.Add(new PhysicalItemType() { Id = 1, Name = "专科检查" });
                pis.Add(new PhysicalItemType() { Id = 2, Name = "化验室项目" });
                pis.Add(new PhysicalItemType() { Id = 3, Name = "影像功能检查" });
                pis.Add(new PhysicalItemType() { Id = 4, Name = "其它" });
                pis.Add(new PhysicalItemType() { Id = 5, Name = "妇科检查" });
                cnn.InsertAll<PhysicalItemType>(pis);

                #endregion

                #region 添加体检项

                var items = new List<PhysicalItemDTO>();
                //专科检查
                items.Add(new PhysicalItemDTO()
                {
                    Id=1,
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now,
                    PhysicalItemType=1
                });

                items.Add(new PhysicalItemDTO()
                {
                    Id=2,
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now,
                    PhysicalItemType = 1
                });
                items.Add(new PhysicalItemDTO()
                {
                    Id=3,
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now,
                    PhysicalItemType = 1
                });
                items.Add(new PhysicalItemDTO()
                {
                    Id = 4,
                    Name = "眼科",
                    Purpose = "视力、眼底",
                    Price = 8,
                    CreateTime = DateTime.Now,
                    PhysicalItemType = 1
                });

                items.Add(new PhysicalItemDTO()
                {
                    Id = 5,
                    Name = "耳鼻咽喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price =10,
                    CreateTime = DateTime.Now,
                    PhysicalItemType = 1
                });

                items.Add(new PhysicalItemDTO()
                {
                    Id = 6,
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now,
                    PhysicalItemType = 1
                });
                //todo:更多专业

                //化验室项目
                items.Add(new PhysicalItemDTO() {Id=7,PhysicalItemType = 2, Name = "真空采血", Purpose = "用于化验项目检查", Price = 0, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 8, PhysicalItemType = 2, Name = "血常规", Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。", Price = 28, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 9, PhysicalItemType = 2, Name = "尿常规", Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。", Price = 8, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 10, PhysicalItemType = 2, Name = "肝功能八项", Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。", Price = 59, CreateTime = DateTime.Now });
              

             
                items.Add(new PhysicalItemDTO() { Id = 11, PhysicalItemType = 2, Name = "肾功能三项", Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。", Price = 17, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 12, PhysicalItemType =2, Name = "血脂六项", Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。", Price =48, CreateTime = DateTime.Now });
           

               
                items.Add(new PhysicalItemDTO() { Id = 13, PhysicalItemType = 2, Name = "血糖检查", Purpose = "糖尿病筛查", Price =6, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 14, PhysicalItemType = 2, Name = "乙肝五项（定性）", Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。", Price =25, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 15, PhysicalItemType = 2, Name = "血流变", Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。", Price = 45, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 16, PhysicalItemType = 2, Name = "胃功三项", Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响", Price = 140, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 17, PhysicalItemType = 2, Name = "甲功五项", Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等", Price = 181, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 18, PhysicalItemType = 2, Name = "肿瘤全项", Purpose = "检查各项肿瘤标志物", Price = 380, CreateTime = DateTime.Now });

                //影像功能检查
                items.Add(new PhysicalItemDTO() { Id = 19, PhysicalItemType =3, Name = "腹部彩超", Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。", Price = 110, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 20, PhysicalItemType = 3, Name = "颈动脉超声", Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。", Price = 120, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 21, PhysicalItemType = 3, Name = "子宫附件彩超", Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。", Price = 110, CreateTime = DateTime.Now });


                items.Add(new PhysicalItemDTO() { Id = 22, PhysicalItemType = 3, Name = "甲状腺超声", Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等", Price = 60, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 23, PhysicalItemType = 3, Name = "胸部正位片（胶片）", Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）", Price = 89, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 24, PhysicalItemType = 3, Name = "多导心电图", Purpose = "了解心律失常、心绞痛及心肌供血情况等", Price = 20, CreateTime = DateTime.Now });
                //其它
                items.Add(new PhysicalItemDTO() { Id = 25, PhysicalItemType = 4, Name = "骨密度检测", Purpose = "了解钙流失情况，有无骨质疏松，预测骨折风险性", Price = 70, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 26, PhysicalItemType = 4, Name = "乳腺血氧功能", Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病", Price =120, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 27, PhysicalItemType = 4, Name = "妇科内诊及TCT", Purpose = "检查妇科、宫颈癌前病变", Price = 175, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 28, PhysicalItemType = 4, Name = "碳13呼气试验", Purpose = "胃部幽门螺杆菌检测", Price = 200, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 29, PhysicalItemType = 4, Name = "多导呼吸睡眠监测", Purpose = "睡眼呼吸监测、睡眠呼吸监测过筛实施、脑电图录像监测、电极、电脑血糖", Price = 645, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 30, PhysicalItemType = 4, Name = "材料费", Purpose = "", Price = 0, CreateTime = DateTime.Now });

                //妇科检查
                items.Add(new PhysicalItemDTO() { Id = 31, PhysicalItemType = 5, Name = "病史采集", Purpose = "身体状况、职业史、既往史、个人史、婚姻史、月经及生育史、家族史等。", Price = 0, CreateTime = DateTime.Now });

                items.Add(new PhysicalItemDTO() { Id = 32, PhysicalItemType = 5, Name = "子宫附件彩超", Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。", Price = 110, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 33, PhysicalItemType = 5, Name = "液基细胞检查（TCT）", Purpose = "是目前国际上最先进的一种宫颈癌细胞学检查技术，检出率高，同时还能发现癌前病变，病毒感染、疱疹和微生物感染如霉菌、滴虫等。", Price = 160, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 34, PhysicalItemType = 5, Name = "妇科内诊", Purpose = "各种阴道炎、宫颈炎、附件炎、盆腔炎等。", Price = 15, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 35, PhysicalItemType = 5, Name = "乳腺血氧", Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病。", Price = 120, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 36, PhysicalItemType = 5, Name = "全自动DNA宫颈筛查", Purpose = "筛查人乳头瘤病毒（HPV)有助于早期消除宫颈癌致病因素。", Price = 300, CreateTime = DateTime.Now });
                items.Add(new PhysicalItemDTO() { Id = 37, PhysicalItemType = 5, Name = "材料费", Purpose = "", Price = 0, CreateTime = DateTime.Now });
                cnn.InsertAll<PhysicalItemDTO>(items);

                #region 备用数据

                /*
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力，辨色力",
                    Price = 4,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能两项",
                    Purpose = "谷丙转氨酶、谷草转氨酶，是检测肝胆功能及损伤程度的重要指标。",
                    Price = 12,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂两项",
                    Purpose = "了解血液中甘油三酯、总胆固醇，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 16,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖",
                    Purpose = "了解血液中甘油三酯、总胆固醇，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 6,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片（纸片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常，心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能六项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂四项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "女：子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "男：前列腺彩超",
                    Purpose = "检查有无前列腺增生、前列腺炎、前列腺肿瘤等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺彩超",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能六项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂四项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "劲动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部证伪片（胶片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "解钙流失情况，有无骨质疏松，预测骨折风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能六项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂四项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "劲动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 0,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧功能",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病",
                    Price = 120,
                    CreateTime = DateTime.Now

                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now          
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能六项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂四项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price =360,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "前列腺彩超",
                    Purpose = "检查有无前列腺增生、前列腺炎、前列腺肿瘤等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺彩超",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气实验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能六项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂四项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 32,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 360,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片（胶片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测骨折风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧功能",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "妇科内诊及TCT",
                    Purpose = "检查妇科、宫颈癌前病变",
                    Price = 175,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气实验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 292,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 360,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "前列腺彩超",
                    Purpose = "检查有无前列腺增生、前列腺炎、前列腺肿瘤等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气实验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功能三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 181,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 380,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片（胶片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧功能",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病",
                    Price = 120,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "妇科内诊及TCT",
                    Purpose = "检查妇科、宫颈癌前病变",
                    Price = 175,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气试验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 200,
                    CreateTime = DateTime.Now

                });
                
                //6类男
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 292,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 360,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "前列腺彩超",
                    Purpose = "检查有无前列腺增生、前列腺炎、前列腺肿瘤等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气实验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "便携呼吸睡眠监测",
                    Purpose = "睡眼呼吸监测、睡眠呼吸监测过筛实施、脑电图录像监测",
                    Price = 515,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功能三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 181,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 380,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片（胶片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧功能",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病",
                    Price = 120,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "妇科内诊及TCT",
                    Purpose = "检查妇科、宫颈癌前病变",
                    Price = 175,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气试验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "便携呼吸睡眠检测",
                    Purpose = "睡眼呼吸监测、睡眠呼吸监测过筛实施、脑电图录像监测",
                    Price = 515,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now

                });
                //7类男
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 292,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 360,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "前列腺彩超",
                    Purpose = "检查有无前列腺增生、前列腺炎、前列腺肿瘤等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气实验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "住院多导呼吸睡眠监测",
                    Purpose = "睡眼呼吸监测、睡眠呼吸监测过筛实施、脑电图录像监测、电极、电脑血糖",
                    Price = 645,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now
                });




                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "一般检查",
                    Purpose = "身高、体重、血压、体重指数",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "内科",
                    Purpose = "血压、发育及营养状况、神经及精神、肺及呼吸道、心脏及血管腹部器官等",
                    Price = 4,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "外科",
                    Purpose = "淋巴、甲状腺、皮肤、脊柱、四肢、关节等",
                    Price = 3,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "眼科",
                    Purpose = "视力、色觉、眼底",
                    Price = 80,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "耳鼻喉科",
                    Purpose = "通过对耳、鼻、咽、扁桃喉等器官的常规检查，初步筛查常见疾病。",
                    Price = 10,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "口腔科",
                    Purpose = "检测牙齿有无龋齿、牙龈和口腔内粘膜的健康状况。",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "真空采血",
                    Purpose = "用于化验项目检查",
                    Price = 10,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血常规",
                    Purpose = "白细胞计数、血红蛋白浓度、红细胞计数、血小板计数、淋巴细胞绝对值等，用于了解血液中的有形成份有无异常，如有贫血、感染、血小板减少等。",
                    Price = 28,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "尿常规",
                    Purpose = "尿外观、尿蛋白、尿糖、尿胆红素、尿胆原、尿潜血等项目，对肾脏、泌尿系统疾感染、结石、糖尿病等多种疾病进行筛查。                                   ",
                    Price = 8,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肝功能八项",
                    Purpose = "谷丙转氨酶、谷草转氨酶、总蛋白、白蛋白、总胆红素、直接胆红素等八项指标，是检测肝胆功能及损伤程度的重要指标，如肝细胞有无受损和肝脏合成蛋白质含量及水平变化情况等。",
                    Price = 59,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肾功能三项",
                    Purpose = "尿素、肌肝、尿酸，了解肾脏功能及损害情况。",
                    Price = 17,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血脂六项",
                    Purpose = "了解血液中甘油三酯、总胆固醇、高密度蛋白、低密度蛋白、 载脂蛋白A1(Apo-A1)、 载脂蛋白B(Apo-B)，反映机体代谢情况的重要指标，该项检查可以确定血液中血脂成分有无异常。",
                    Price = 48,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血糖检查",
                    Purpose = "糖尿病筛查",
                    Price = 6,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乙肝五项（定性）",
                    Purpose = "表面抗原（HBsAg）、表面抗体（HBsAb）、e-抗原（HBeAg） 、e-抗体（HBeAb）、核心抗体（HBcAb） ，了解是否感染乙肝病毒。                                        ",
                    Price = 25,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "血流变",
                    Purpose = "检测血液粘稠度、是否有高粘血症，预测中风。",
                    Price = 45,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胃功能三项",
                    Purpose = "检测胃炎 、胃溃疡等疾病对胃功能的影响",
                    Price = 140,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲功五项",
                    Purpose = "检测甲状腺功能、急性甲状腺炎、甲亢等",
                    Price = 181,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "肿瘤全项",
                    Purpose = "检查各项肿瘤标志物",
                    Price = 380,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "腹部彩超",
                    Purpose = "了解肝、胆、胰、脾、双肾 其形态结构，检查有无脂肪肝、肝囊肿、肝肿瘤、胆结石、胆囊息肉人、胆囊肿瘤、脾脏大小、胰腺大小、双肾大小、肾结石、肾肿瘤等。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });

                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "颈动脉超声",
                    Purpose = "了解双侧颈动脉有无斑块、动脉硬化、畸形狭窄等。",
                    Price = 120,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "甲状腺超声",
                    Purpose = "筛查甲状腺结节、囊肿、甲状腺瘤、甲状腺癌等",
                    Price = 60,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "胸部正位片（胶片）",
                    Purpose = "心、肺、膈肌的形态结构及各种胸部疾病（注：此项检查属于X射线检查，大剂量对人体有一定的影响请谨慎选择，忌一年多次照射）",
                    Price = 89,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "多导心电图",
                    Purpose = "了解心律失常、心绞痛及心肌供血情况等",
                    Price = 20,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "骨密度检测",
                    Purpose = "了解钙流失情况，有无骨质疏松，预测顾着风险性",
                    Price = 70,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧功能",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病",
                    Price = 120,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "妇科内诊及TCT",
                    Purpose = "检查妇科、宫颈癌前病变",
                    Price = 175,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "碳13呼气试验",
                    Purpose = "胃部幽门螺杆菌检测",
                    Price = 200,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "住院多导呼吸睡眠监测",
                    Purpose = "睡眼呼吸监测、睡眠呼吸监测过筛实施、脑电图录像监测、电极、电脑血糖",
                    Price = 645,
                    CreateTime = DateTime.Now
                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "材料费",
                    Purpose = "打印材料",
                    Price = 0,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "病史采集",
                    Purpose = "身体状况、职业史、既往史、个人史、婚姻史、月经及生育史、家族史等。",
                    Price = 0,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "子宫附件彩超",
                    Purpose = "了解子宫大小、形态、有无妊娠、肿瘤等；了解盆腔附件有无卵巢囊肿、盆腔积液等疾病。",
                    Price = 110,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "液基细胞检查（TCT）",
                    Purpose = "是目前国际上最先进的一种宫颈癌细胞学检查技术，检出率高，同时还能发现癌前病变，病毒感染、疱疹和微生物感染如霉菌、滴虫等。",
                    Price = 160,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "妇科内诊",
                    Purpose = "各种阴道炎、宫颈炎、附件炎、盆腔炎等。",
                    Price = 15,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "乳腺血氧",
                    Purpose = "筛查乳腺增生、乳腺囊肿、乳腺肿瘤等疾病。",
                    Price = 120,
                    CreateTime = DateTime.Now

                });
                cnn.Insert<PhysicalItemDTO>(new PhysicalItemDTO()
                {
                    Name = "全自动DNA宫颈筛查",
                    Purpose = "筛查人乳头瘤病毒（HPV)有助于早期消除宫颈癌致病因素。",
                    Price = 300,
                    CreateTime = DateTime.Now

                });
                */
                #endregion

                #endregion

                #region 添加体检类型

                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id=1, Name = "入职体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 2, Name = "老年体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 3, Name = "中年体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 4, Name = "青年体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 5, Name = "儿童体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 6, Name = "女性体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 7, Name = "婚前检查" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 8, Name = "常规体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 9, Name = "孕前检查" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 10, Name = "产后检查" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 11, Name = "公务员套餐" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 12, Name = "健康证体检" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 13, Name = "防癌检查" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 14, Name = "职场白领" });
                cnn.Insert<ComboTypeDTO>(new ComboTypeDTO { Id = 15, Name = "特惠体检" });

                #endregion

                //套餐1：入职体检套餐A
                var combo = new ComboDTO();
                combo.Id = 1;
                combo.Name = "入职体检套餐A";
                combo.Price = 148;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 148;
                combo.Sonnum = 99;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";
                
                var comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 1, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //测试套餐：价格0.01 为了微信支付测试
                combo = new ComboDTO();
                combo.Id = 2;
                combo.Name = "微信支付测试套餐";
                combo.Price = 0.01M;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 88;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 2, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加入职体检B套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 3;
                combo.Name = "入职体检套餐B";
                combo.Price =301;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 3, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加1类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 4;
                combo.Name = "1类套餐";
                combo.Price = 382;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 4, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加2类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 5;
                combo.Name = "2类套餐";
                combo.Price = 528;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 5, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 6;
                combo.Name = "3类套餐(男)";
                combo.Price = 782;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 6, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 7;
                combo.Name = "3类套餐(女)";
                combo.Price = 902;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 7, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 8;
                combo.Name = "4类体检套餐(男)";
                combo.Price =1370;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 8, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 9;
                combo.Name = "4类体检套餐(女)";
                combo.Price = 1685;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 9, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 10;
                combo.Name = "5类体检套餐(男)";
                combo.Price = 1734;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 10, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 11;
                combo.Name = "5类体检套餐(女)";
                combo.Price = 2049;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 11, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 12;
                combo.Name = "6类体检套餐(男)";
                combo.Price = 2249;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 12, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                //添加3类套餐
                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 13;
                combo.Name = "6类体检套餐(女)";
                combo.Price = 2564;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 13, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 14;
                combo.Name = "7类体检套餐(男)";
                combo.Price = 2379;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 14, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 15;
                combo.Name = "7类体检套餐(女)";
                combo.Price = 2694;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 15, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);

                combo = new ComboDTO();//实例化套餐对像
                combo.Id = 16;
                combo.Name = "妇科套餐";
                combo.Price = 705;
                combo.Single = false;
                combo.Appropriate = "入职体检人群";
                combo.ComboTypeId = 1;
                combo.Details = "适合入职体检";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = 0.01M; ;
                combo.Sonnum = 0;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "";

                comboItems = new List<ComboToPhysicalItemDTO>();
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 1 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 2 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 3 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 4 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 5 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 6 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 7 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 8 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 9 });
                comboItems.Add(new ComboToPhysicalItemDTO() { ComboId = 16, PhysicalItemId = 10 });

                cnn.Insert<ComboDTO>(combo);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboItems);
                #region 备用套餐数据

                /*
                //1
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 100;
                combo.Single = false;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 1;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(150.000000);
                combo.Sonnum = 999;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201601/l_1452756079.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                var comboId = cnn.Insert<ComboDTO>(combo);

                var comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                var comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //2
                combo = new ComboDTO();
                combo.Name = "常规单项体（女）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 1;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //3
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（女）";
                combo.Price = 50;
                combo.Single = false;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 2;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //4
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 2;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //5
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 3;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //6
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 3;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //2
                combo = new ComboDTO();
                combo.Name = "常规单项体（女）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 4;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //3
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（女）";
                combo.Price = 50;
                combo.Single = false;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 4;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //4
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 5;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //5
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 5;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //6
                combo = new ComboDTO();
                combo.Name = "常规体检套餐（男）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 6;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/combos/201507/l_1438054670.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";

                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);

                //7
                combo = new ComboDTO();
                combo.Name = "妈妈宝宝双人检（女）";
                combo.Price = 50;
                combo.Single = true;
                combo.Appropriate = "公司白领";
                combo.ComboTypeId = 7;
                combo.Details = "适合公司办公人员，常规检测，职业病、亚健康人群。";
                combo.HospitalId = 1;
                combo.CreateTime = DateTime.Now;
                combo.Oldprice = Convert.ToDecimal(100.000000);
                combo.Sonnum = 8888;
                combo.PicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                combo.Scheck = "肿瘤筛查、肝病、甲状腺疾病";
                comboId = cnn.Insert<ComboDTO>(combo);
                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);
                comboId = cnn.Insert<ComboDTO>(combo);

                comboToPhysicals = new List<ComboToPhysicalItemDTO>();
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 1;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical = new ComboToPhysicalItemDTO();
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 2;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 3;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 4;
                comboToPhysicals.Add(comboToPhysical);
                comboToPhysical.ComboId = (int)comboId;
                comboToPhysical.PhysicalItemId = 5;
                comboToPhysicals.Add(comboToPhysical);
                cnn.InsertAll<ComboToPhysicalItemDTO>(comboToPhysicals);
                */

                #endregion

                return true;
            }
        }

        public bool InitialOrder()
        {
            using (var cnn = DbConnection)
            {
                cnn.DropAndCreateTable<Cart>();
                var cart = new Cart();
                cart.UserId = 1;
                cart.ComboId = 1;
                cart.Count = 1;
                cnn.Insert<Cart>(cart);

                cnn.DropAndCreateTable<Order>();

                var order = new Order();
                order.Ordercode = "4566565";
                order.PayCode = "51635155";
                order.UserId = 2;
                order.SumPrice = Convert.ToDecimal(600.000000);
                order.PreferentialPrice = Convert.ToDecimal(480.000000);
                order.CreateDate = "2016-11-7";
                order.BookerName = "user";
                order.BookerPhone = "18554562585";
                order.BookerSex = 1;
                order.State = 0;
                order.PayType = 1;
                order.ValidateCode = "2525";
                order.TpeopleAdd = "130106197904253911";
                cnn.Insert<Order>(order);
                cnn.DropAndCreateTable<OrderDetail>();
                cnn.DropAndCreateTable<PhysicalPeople>();

                return true;
            }
        }

        /// <summary>
        /// 回复表
        /// </summary>
        /// <returns></returns>
        public bool InitialReply()
        {
            using (var cnn = DbConnection)
            {
                cnn.DropAndCreateTable<ReplyDTO>();
                var h = new ReplyDTO();
                h.Pname = "Admin";
                h.Rcontent = "这家医院特别好";
                h.Qid = 1;
                h.Rdate = "2016-05-08";
                cnn.Insert<ReplyDTO>(h);

                var h1 = new ReplyDTO();
                h1.Pname = "Admin";
                h1.Rcontent = "这家医院不错";
                h1.Qid = 2;
                h1.Rdate = "2016-05-08";
                cnn.Insert<ReplyDTO>(h1);

                var h2 = new ReplyDTO();
                h2.Pname = "Admin";
                h2.Rcontent = "这家医院特别6";
                h2.Qid = 3;
                h2.Rdate = "2016-05-08";
                cnn.Insert<ReplyDTO>(h2);
                return true;
            }
        }

        public bool InitialtuanOrder()
        {
            using (var cnn = DbConnection)
            {
                cnn.DropAndCreateTable<TuanOrderDTO>();
                var tuan = new TuanOrderDTO();
                tuan.Sonnum = 1;//<10人
                tuan.Yusuan = 1;//<200元每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 1;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);
                tuan.Sonnum = 2;//10-20人
                tuan.Yusuan = 2;//200-300元每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 2;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);
                tuan.Sonnum = 2;//10-20人
                tuan.Yusuan = 3;//300-400元每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 3;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);
                tuan.Sonnum = 2;//10-20人
                tuan.Yusuan = 4;//400-500元每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 4;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);
                tuan.Sonnum = 2;//10-20人
                tuan.Yusuan = 5;//500以上每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 5;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);
                tuan.Sonnum = 3;//50人以上
                tuan.Yusuan = 2;//200-300元每人
                tuan.Uname = "user";
                tuan.Utell = "18401632376";
                tuan.Tdate = "2016-11-06";
                tuan.HospitalId = 6;
                tuan.Tstate = 0;
                cnn.Insert<TuanOrderDTO>(tuan);


                return true;
            }
        }

        /// <summary>
        /// 初始化数据库
        /// </summary>
        /// <returns></returns>
        public bool Initial()
        {
            using (var cnn = DbConnection)
            {
                cnn.From<UserDTO>()
                    .Update(m => m.PhoneNumber)
                    .Where(m => m.Id == 1);



                /*
                //创建单项体检表
                cnn.DropAndCreateTable<Personalized_ExaminationDTO>();
                //添加测试单项体检信息
                var personalized = new Personalized_ExaminationDTO();
                personalized.HospitalId = 1;
                personalized.Name = "内科体检C";
                personalized.PhysicalExaminationId = 1;
                personalized.Price = 59.9M;
                personalized.Appropriate = "青年，老年";
                personalized.Count = 15;
                personalized.Detail = "我医院的优惠活动";
                new PersonalizedDAL().Add(personalized);

                ///创建套餐类型表
                DbConnection.DropAndCreateTable<ComboTypeDTO>();
               
                //套餐表
                DbConnection.DropAndCreateTable<ComboDTO>();
                */

                //体检人员表 
                DbConnection.DropAndCreateTable<PhysicalPeople>();
                /*
                //体检报告表
                DbConnection.DropAndCreateTable<Examination_ReportDTO>();

                //体检百科栏目表
                DbConnection.DropAndCreateTable<ArticleColDTO>();

                //体检百科文章表
                DbConnection.DropAndCreateTable<ArticleDTO>();
                */
            }

            return true;
        }


        /// <summary>
        /// 城市
        /// </summary>
        /// <returns></returns>
        public bool InitialCity()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<City>();
                cnn.DropAndCreateTable<Region>();

                //添加测试数据
                var city = new City();
                city.Name = "石家庄";
                var cid1 = cnn.Insert<City>(city);

                var region = new Region();
                region.Name = "长安区";
                region.CityId = (int)cid1;
                cnn.Insert<Region>(region);

                region = new Region();
                region.Name = "桥西区";
                region.CityId = (int)cid1;
                cnn.Insert<Region>(region);

                city = new City();
                city.Name = "北京";
                var cid2 = cnn.Insert<City>(city);

                var region1 = new Region();
                region1.Name = "海淀区";
                region1.CityId = (int)cid2;
                cnn.Insert<Region>(region1);

                region1 = new Region();
                region1.Name = "大兴区";
                region1.CityId = (int)cid2;
                cnn.Insert<Region>(region1);

                city = new City();
                city.Name = "上海";
                var cid3 = cnn.Insert<City>(city);

                var region2 = new Region();
                region2.Name = "黄埔区";
                region2.CityId = (int)cid3;
                cnn.Insert<Region>(region2);

                region2 = new Region();
                region2.Name = "海区";
                region2.CityId = (int)cid3;
                cnn.Insert<Region>(region2);

                return true;
            }
        }
        /// <summary>
        /// 问题表
        /// </summary>
        /// <returns></returns>
        public bool InitialQuestions()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<questions>();

                //添加测试数据
                var question = new questions();
                question.content = "aaa";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 1;
                question.Tid = 1;
                question.Qhits = 50;
                question.Qdate = "2016-06-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "bbb";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 2;
                question.Tid = 1;
                question.Qhits = 40;
                question.Qdate = "2016-07-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "ccc";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 1;
                question.Tid = 2;
                question.Qhits = 40;
                question.Qdate = "2016-07-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "ccc";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 2;
                question.Tid = 2;
                question.Qhits = 40;
                question.Qdate = "2016-07-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "ccc";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 3;
                question.Tid = 2;
                question.Qhits = 40;
                question.Qdate = "2016-07-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "ccc";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 4;
                question.Tid = 2;
                question.Qhits = 40;
                question.Qdate = "2016-07-09";
                cnn.Insert<questions>(question);

                question = new questions();
                question.content = "ccc";
                question.Qage = 10;
                question.Qphone = "15010222570";
                question.Qsex = "男";
                question.Qstate = "已解答";
                question.Uid = 1;
                question.ttid = 1;
                question.Tid = 3;
                question.Qhits = 40;
                question.Qdate = "2016-06-09";
                cnn.Insert<questions>(question);

                return true;
            }
        }
        /// <summary>
        /// 回复表
        /// </summary>
        /// <returns></returns>
        public bool InitialResponse()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<ResponseDTO>();

                //添加测试数据
                var res = new ResponseDTO();
                res.Qid = 1;
                res.Rcontent = "服务态度是相当的不错啦";
                res.Rdate = Convert.ToDateTime("2016-11-12");
                res.Kid = "Admin";
                cnn.Insert<ResponseDTO>(res);

                var res1 = new ResponseDTO();
                res1.Qid = 2;
                res1.Rcontent = "医院的科技很发达不错";
                res1.Rdate = Convert.ToDateTime("2016-10-12");
                res1.Kid = "Admin";
                cnn.Insert<ResponseDTO>(res);


                return true;
            }
        }
        public bool InitialPriv()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Priv>();

                //添加测试数据
                var pri = new Priv();
                pri.Pname = "123";
                pri.Pcoent = "双十一优惠券";
                pri.Pzt = 0;
                cnn.Insert<Priv>(pri);

                pri = new Priv();
                pri.Pname = "456";
                pri.Pcoent = "会员优惠券";
                pri.Pzt = 1;
                cnn.Insert<Priv>(pri);

                pri = new Priv();
                pri.Pname = "789";
                pri.Pcoent = "普通会员优惠券";
                pri.Pzt = 2;
                cnn.Insert<Priv>(pri);
                return true;
            }
        }
        public bool subscribe()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<subscrib>();

                //添加测试数据
                var question = new subscrib();
                question.Cid = 1;
                question.Phyname = "张三";
                question.PhyDate = Convert.ToDateTime("2016-11-11");
                question.PhyPhone = "15010222570";
                question.Physex = "男";
                question.Phycard = "232126199712020177";
                question.marital = "已婚";
                question.Phyprice = 111;
                question.makePhone = "18945635111";
                question.remark = "哈哈哈哈哈！";
                cnn.Insert<subscrib>(question);
                return true;
            }
        }

        /// <summary>
        /// 热门表
        /// </summary>
        /// <returns></returns>
        public bool recommend()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<recommen>();

                //添加测试数据
                var question = new recommen();
                question.name = "特惠体检";
                question.url = "tuangou.html";
                question.img = "thtj";
                cnn.Insert<recommen>(question);

                var question1 = new recommen();
                question1.name = "防癌检查";
                question1.url = "pet_ct.html";
                question1.img = "fatj";
                cnn.Insert<recommen>(question1);

                var question2 = new recommen();
                question2.name = "体检问答";
                question2.url = "Ask.html";
                question2.img = "tjwd";
                cnn.Insert<recommen>(question2);

                var question3 = new recommen();
                question3.name = "体检指南";
                question3.url = "viptijian_newslist.html";
                question3.img = "tjzn";
                cnn.Insert<recommen>(question3);

                var question4 = new recommen();
                question4.name = "常规体检";
                question4.url = "tj_list.html";
                question4.img = "cgtj";
                cnn.Insert<recommen>(question4);

                var question5 = new recommen();
                question5.name = "职场白领";
                question5.url = "tj_list.html";
                question5.img = "zcbl";
                cnn.Insert<recommen>(question5);

                var question6 = new recommen();
                question6.name = "孕前体检";
                question6.url = "tj_list.html";
                question6.img = "yqtj";
                cnn.Insert<recommen>(question6);

                var question7 = new recommen();
                question7.name = "全部";
                question7.url = "all_combo_type.html";
                question7.img = "gdnav";
                cnn.Insert<recommen>(question7);
                return true;
            }
        }

        /// <summary>
        /// 评价类别
        /// </summary>
        /// <returns></returns>
        public bool InitialApptype()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Apptype>();

                //添加测试数据
                var apptype = new Apptype();
                apptype.Aname = "挺好";
                cnn.Insert<Apptype>(apptype);
                return true;
            }
        }
        /// <summary>
        /// 评价表
        /// </summary>
        /// <returns></returns>
        public bool InitialAppDTO()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<AppDTO>();

                //添加测试数据
                var app = new AppDTO();
                app.uid = 1;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "dfdgeg大哥哥特地方大幅度大范甘迪";
                app.Aid = 1;
                app.pzhuangtai = 1;
                cnn.Insert<AppDTO>(app);

                app = new AppDTO();
                app.uid = 2;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "真的还不错";
                app.Aid = 2;
                app.pzhuangtai = 0;
                cnn.Insert<AppDTO>(app);

                app = new AppDTO();
                app.uid = 2;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "我想弄好，真的好头疼";
                app.Aid = 2;
                app.pzhuangtai = 1;
                cnn.Insert<AppDTO>(app);

                app = new AppDTO();
                app.uid = 1;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "好省心，简单明了";
                app.Aid = 1;
                app.pzhuangtai = 1;
                cnn.Insert<AppDTO>(app);

                app = new AppDTO();
                app.uid = 1;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "真的还不错,你看看吧";
                app.Aid = 2;
                app.pzhuangtai = 0;
                cnn.Insert<AppDTO>(app);

                app = new AppDTO();
                app.uid = 6;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "真的还不错";
                app.Aid = 2;
                app.pzhuangtai = 0;
                cnn.Insert<AppDTO>(app);
                app = new AppDTO();
                app.uid = 6;
                app.pdate = "2014/2/1";
                app.pcount = 211;
                app.pcontent = "试试嘛，又不贵";
                app.Aid = 2;
                app.pzhuangtai = 1;
                cnn.Insert<AppDTO>(app);
                return true;
            }
        }

        /// <summary>
        /// 图片表
        /// </summary>
        /// <returns></returns>
        public bool InitialImage()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<AppImage>();

                //添加测试数据
                var ima = new AppImage();
                ima.Url = "Public/Mobile/images/banner_01.jpg";
                ima.Link = "tj_list.html";
                cnn.Insert<AppImage>(ima);

                ima = new AppImage();
                ima.Url = "Public/Mobile/images/banner_02.jpg";
                ima.Link = "tj_list.html";
                cnn.Insert<AppImage>(ima);

                ima = new AppImage();
                ima.Url = "Public/Mobile/images/banner_03.jpg";
                ima.Link = "news-zt.html";
                cnn.Insert<AppImage>(ima);

                return true;
            }
        }

        public bool Initailcombo2()
        {
            using (var cnn = DbConnection)
            {
                //创建套餐表
                cnn.DropAndCreateTable<combo2>();
                //添加测试账号
                var com = new combo2();
                com.Cid = 1;
                com.Cname = "第三方斯蒂芬";
                com.Cnowprice = 2;
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439867035.jpg";
                com.Cprice = 4;
                com.Csonnum = 100;
                new com2dal().Add(com);
                var com1 = new combo2();
                com1.Cid = 2;
                com1.Cname = "第三方斯蒂芬";
                com1.Cnowprice = 20;
                com1.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com1.Cprice = 50;
                com1.Csonnum = 100;
                new com2dal().Add(com1);
            }
            return true;
        }
        /// <summary>
        /// 体保
        /// </summary>
        /// <returns></returns>
        public bool Initailtibao()
        {
            using (var conn = DbConnection)
            {
                //创建体检表
                conn.DropAndCreateTable<tibao>();
                //添加测试账号
                var tibao = new tibao();
                tibao.tbid = 1;
                tibao.orderid = 1;
                tibao.physicalexaminationId = 1;
                tibao.examinationpeopleid = 1;
                tibao.Result = "一切正常";
                new tbdal().Add(tibao);
                var tibao1 = new tibao();
                tibao1.tbid = 2;
                tibao1.orderid = 2;
                tibao1.physicalexaminationId = 2;
                tibao1.examinationpeopleid = 2;
                tibao1.Result = "有点不正常";
                new tbdal().Add(tibao1);
            }
            return true;
        }
        public bool Initialzhao()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Zhao>();

                //添加测试数据
                var zhao = new Zhao();
                zhao.zname = "找医院";
                zhao.zcontent = "公立三甲医院/专业体检中心";
                zhao.imgurl = "Public/mobile/images/zyy_icon.png";
                zhao.yiyuanurl = "hospital_list.html";
                cnn.Insert<Zhao>(zhao);

                zhao.zname = "找套餐";
                zhao.zcontent = "丰富全面的检查种类";
                zhao.imgurl = "ztc_box rt";
                zhao.yiyuanurl = "tj_list.html";
                cnn.Insert<Zhao>(zhao);


                zhao.zname = "企业团检";
                zhao.zcontent = "为团体量身定制";
                zhao.imgurl = "tj_box rt";
                zhao.yiyuanurl = "company_examine.html";
                cnn.Insert<Zhao>(zhao);

                zhao.zname = "体检定制";
                zhao.zcontent = "健康大数据智能匹配适合您的体检套餐";
                zhao.imgurl = "tjdz_box";
                zhao.yiyuanurl = "Custom/index.html";
                cnn.Insert<Zhao>(zhao);

                zhao.zname = "报告管理";
                zhao.zcontent = "报告云存储，专家解读、体检推荐";
                zhao.imgurl = "bggl_box";
                zhao.yiyuanurl = "dbg.html";
                cnn.Insert<Zhao>(zhao);
                return true;
            }
        }
        public bool Initialcombo2()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<combo2>();

                //添加测试数据

                combo2 com = new combo2();
                com.Cid = 5;
                com.Cname = "常规套餐";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1300;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 1;
                com.Cname = "优惠套餐";
                com.Cprice = Convert.ToDecimal(656.5);
                com.Cnowprice = Convert.ToDecimal(300.0);
                com.Csonnum = 1400;
                com.csex = "女";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866904.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 1;
                com.Cname = "大吐血优惠价";
                com.Cprice = Convert.ToDecimal(6666);
                com.Cnowprice = Convert.ToDecimal(6660);
                com.Csonnum = 88888;
                com.csex = "女";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866904.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);


                com.Cid = 5;
                com.Cname = "普通体检套餐";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 5;
                com.Cname = "常规体检";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 6;
                com.Cname = "白领体检";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 6;
                com.Cname = "花姑娘体检套餐";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "女";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 7;
                com.Cname = "妈妈宝宝双人检";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 2;
                com.Cname = "防癌检查";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);

                com.Cid = 2;
                com.Cname = "防各种癌";
                com.Cprice = Convert.ToDecimal(956.5);
                com.Cnowprice = Convert.ToDecimal(550);
                com.Csonnum = 1500;
                com.csex = "男";
                com.CpicUrl = "http://www.viptijian.com/Uploads/images/tuangou/201508/l_1439866216.jpg";
                com.uid = 1;
                com.aid = 2;
                cnn.Insert<combo2>(com);


                return true;
            }
        }
        public bool Initialcapacity()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Capacity>();

                //添加测试数据
                var cap = new Capacity();
                cap.zname = "体检定制";
                cap.zcontent = "健康大数据智能匹配适合您的体检套餐";
                cap.imgurl = "tjdz_box";
                cap.yiyuanurl = "Custom/index.html";
                cnn.Insert<Capacity>(cap);

                cap.zname = "报告管理";
                cap.zcontent = "报告云存储，专家解读、体检推荐";
                cap.imgurl = "bggl_box";
                cap.yiyuanurl = "dbg.html";
                cnn.Insert<Capacity>(cap);
                return true;
            }
        }
        public bool Initialspeedy_dto()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<speedy_dto>();

                //添加测试数据
                var spee = new speedy_dto();
                spee.sname = "中国人们医院";
                spee.content = "公立三甲";
                spee.surl = "http://www.viptijian.com/Uploads/images/units/201210/20121023155255728_M.JPG";
                spee.statisticscount = 4688;
                spee.juli = 1988;
                cnn.Insert<speedy_dto>(spee);

                spee.sname = "北京爱康医院";
                spee.content = "专业体检中心";
                spee.surl = "http://www.viptijian.com/Uploads/images/units/201506/m_1434521683.jpg";
                spee.statisticscount = 4688;
                spee.juli = 1988;
                cnn.Insert<speedy_dto>(spee);
                return true;
            }
        }

        public bool InitialZuheComboDTO()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<ZuheComboDTO>();
                //建表
                cnn.DropAndCreateTable<ZuhetoCombo>();
                //添加测试数据
                var zuhe = new ZuheComboDTO();
                zuhe.Zname = "【关爱中年基础体检】组合套餐推荐";
                cnn.Insert<ZuheComboDTO>(zuhe);



                //添加测试数据
                var zuhef = new ZuhetoCombo();
                zuhef.Cid = 1;
                zuhef.Zid = 1;
                cnn.Insert<ZuhetoCombo>(zuhef);
                zuhef.Cid = 2;
                zuhef.Zid = 1;
                cnn.Insert<ZuhetoCombo>(zuhef);
                return true;
            }
        }


        /// <summary>
        /// 获取适合人群名称
        /// </summary>
        /// <returns></returns>
        public bool InitialCrowd()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<CrowdDTO>();

                //添加测试数据
                var crowd = new CrowdDTO();
                crowd.Nname = "未婚女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "已婚女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "公务员";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "中年男性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "中年女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "老年女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "中老年女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "中老年男性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "亚健康人群";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "青年男性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "青年女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "儿童";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "离休干部人群";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "冠心病人群";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "产后女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "学生女性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "学生男性";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "大学生人群";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "学生";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "就业人群";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "司机";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "保姆";

                cnn.Insert<CrowdDTO>(crowd);
                crowd.Nname = "学龄前宝宝";

                cnn.Insert<CrowdDTO>(crowd);


                return true;
            }
        }


        /// <summary>
        /// 体检范围类别
        /// </summary>
        /// <returns></returns>
        public bool InitialClassifyType()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<ClassifyType>();

                //添加测试数据
                var classtype = new ClassifyType();
                classtype.Name = "儿童";
                cnn.Insert<ClassifyType>(classtype);

                //添加测试数据
                classtype = new ClassifyType();
                classtype.Name = "青年";
                cnn.Insert<ClassifyType>(classtype);

                //添加测试数据
                classtype = new ClassifyType();
                classtype.Name = "中年";
                cnn.Insert<ClassifyType>(classtype);

                //添加测试数据
                classtype = new ClassifyType();
                classtype.Name = "老年";
                cnn.Insert<ClassifyType>(classtype);
                return true;
            }
        }

        /// <summary>
        /// 具体体检项分类
        /// </summary>
        /// <returns></returns>
        public bool InitialClassify()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Classify>();

                //添加测试数据
                var classify = new Classify();
                classify.Name = "基础体检";
                classify.Tid = 1;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "全身体检";
                classify.Tid = 1;
                cnn.Insert<Classify>(classify);

                //添加测试数据
                classify = new Classify();
                classify.Name = "基础体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "入职体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "防癌体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "婚前体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "全身体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "白领体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
               //添加测试数据
                classify = new Classify();
                classify.Name = "妇科体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "孕前体检";
                classify.Tid = 2;
                cnn.Insert<Classify>(classify);

                //添加测试数据
                classify = new Classify();
                classify.Name = "基础体检";
                classify.Tid = 3;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "入职体检";
                classify.Tid = 3;
                cnn.Insert<Classify>(classify);


                //添加测试数据
                classify = new Classify();
                classify.Name = "基础体检";
                classify.Tid = 4;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "防癌体检";
                classify.Tid = 4;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "全身体检";
                classify.Tid = 4;
                cnn.Insert<Classify>(classify);
                //添加测试数据
                classify = new Classify();
                classify.Name = "妇科体检";
                classify.Tid = 4;
                cnn.Insert<Classify>(classify);


                return true;
            }
        }

        /// <summary>
        /// 客服表
        /// </summary>
        /// <returns></returns>
        public bool InitialEsq()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<Esq>();

                //添加测试数据
                var esq= new Esq();
                esq.Name = "青蓝";
                esq.Count = 1;
                cnn.Insert<Esq>(esq);
                return true;
            }
        }
        /// <summary>
        ///体检指南类别
        /// </summary>
        /// <returns></returns>
        public bool InitialPhysicalType()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<PhysicalType>();

                //添加测试数据
                var Phytype = new PhysicalType();
                Phytype.PhysicalName = "体检常识";
                cnn.Insert<PhysicalType>(Phytype);

                var Phytype1 = new PhysicalType();
                 Phytype1.PhysicalName = "健康热点";
                 cnn.Insert<PhysicalType>(Phytype1);

                 var Phytype2 = new PhysicalType();
                 Phytype2.PhysicalName = "体检优惠活动";
                 cnn.Insert<PhysicalType>(Phytype2);

                 var Phytype3 = new PhysicalType();
                 Phytype3.PhysicalName = "体检优体检报告解读惠活动";
                 cnn.Insert<PhysicalType>(Phytype3);

                 var Phytype4 = new PhysicalType();
                 Phytype4.PhysicalName = "女性体检";
                 cnn.Insert<PhysicalType>(Phytype4);
                

                 var Phytype5 = new PhysicalType();
                Phytype5.PhysicalName = "男性体检";
                cnn.Insert<PhysicalType>(Phytype5);

                var Phytype6 = new PhysicalType();
                Phytype6.PhysicalName = "老年人体检";
                cnn.Insert<PhysicalType>(Phytype6);

                var Phytype7 = new PhysicalType();
                  Phytype7.PhysicalName = "儿童体检";
                  cnn.Insert<PhysicalType>(Phytype7);

                  var Phytype8 = new PhysicalType();
                Phytype8.PhysicalName = "青少年体检";
                cnn.Insert<PhysicalType>(Phytype8);

                var Phytype9 = new PhysicalType();
                Phytype9.PhysicalName = "旅游体检指南";
                cnn.Insert<PhysicalType>(Phytype9);

                var Phytypea = new PhysicalType();
                 Phytypea.PhysicalName = "体检设备介绍";
                 cnn.Insert<PhysicalType>(Phytypea);

                 var Phytypeb = new PhysicalType();
                 Phytypeb.PhysicalName = "B超检查";
                 cnn.Insert<PhysicalType>(Phytypeb);

                 var Phytypec = new PhysicalType();
                Phytypec.PhysicalName = "CT检查";
                cnn.Insert<PhysicalType>(Phytypec);

                var Phytyped = new PhysicalType();
                Phytyped.PhysicalName = "彩超检查";
                cnn.Insert<PhysicalType>(Phytyped);

                var Phytypee = new PhysicalType();
                Phytypee.PhysicalName = "肠镜检查";
                cnn.Insert<PhysicalType>(Phytypee);

                var Phytypef = new PhysicalType();
                 Phytypef.PhysicalName = "肝功能检查";
                 cnn.Insert<PhysicalType>(Phytypef);

                 var Phytypeg = new PhysicalType();
                Phytypeg.PhysicalName = "尿常规检查";
                cnn.Insert<PhysicalType>(Phytypeg);

                var Phytypeh = new PhysicalType();
                Phytypeh.PhysicalName = "肾功能检查";
                cnn.Insert<PhysicalType>(Phytypeh);

                var Phytypei = new PhysicalType();
                Phytypei.PhysicalName = "糖化血红蛋白检查";
                cnn.Insert<PhysicalType>(Phytypei);

                var Phytypej = new PhysicalType();
                Phytypej.PhysicalName = "胃镜检查";
                cnn.Insert<PhysicalType>(Phytypej);

                var Phytypek = new PhysicalType();
                 Phytypek.PhysicalName = "心电图检查";
                 cnn.Insert<PhysicalType>(Phytypek);

                 var Phytypel = new PhysicalType();
                 Phytypel.PhysicalName = "血常规检查";
                 cnn.Insert<PhysicalType>(Phytypel);

                 var Phytypem = new PhysicalType();
                 Phytypem.PhysicalName = "pet-ct知识";
                 cnn.Insert<PhysicalType>(Phytypem);

                 var Phytypen = new PhysicalType();
                Phytypen.PhysicalName = "血沉检查";
                cnn.Insert<PhysicalType>(Phytypen);

                var Phytypeo = new PhysicalType();
                 Phytypeo.PhysicalName = "pet-ct常见问题";
                 
                 cnn.Insert<PhysicalType>(Phytypeo);
                return true;
            }
        }
        
        /// <summary>
        /// 体检指南详情
        /// </summary>
        /// <returns></returns>
        public bool InitialPhysicalNan()
        {
            using (var cnn = DbConnection)
            {
                //建表
                cnn.DropAndCreateTable<PhysicalNan>();

                //添加测试数据
                var pnan = new PhysicalNan();
                pnan.Ptitle = "达康健康服务网全流程信息化服务 优化体检服务品质";
                pnan.Pdate = DateTime.Now.ToString("yyyy/MM/dd");
                pnan.Pwang = "中康体检网";
                pnan.Pcontent = "爱建股份垃圾发电量番窠倒臼";
                pnan.Pid = 1;
                cnn.Insert<PhysicalNan>(pnan);
                //添加测试数据
                var pnan1 = new PhysicalNan();
                pnan1.Ptitle = "达康健康服务网全流程信息化服务 优化体检服务品质";
                pnan1.Pdate = DateTime.Now.ToString("yyyy/MM/dd");
                pnan1.Pwang = "中康体检网";
                pnan1.Pcontent = "爱建股份垃圾发电量番窠倒臼";
                pnan1.Pid = 2;
                cnn.Insert<PhysicalNan>(pnan1);
                //添加测试数据
                var pnan2 = new PhysicalNan();
                pnan2.Ptitle = "达康健康服务网全流程信息化服务 优化体检服务品质";
                pnan2.Pdate = DateTime.Now.ToString("yyyy/MM/dd");
                pnan2.Pcontent = "爱建股份垃圾发电量番窠倒臼";
                pnan2.Pwang = "中康体检网";
                pnan2.Pid = 3;
                cnn.Insert<PhysicalNan>(pnan2);
                return true;
            }
        }
    }
}
